SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateNotice2]
    (
      @param_JOL_Bulletin_No INT,
      @param_JOL_Bulletin_Title VARCHAR(100),
      @param_JOL_Bulletin_Source VARCHAR(100),
      @param_JOL_Bulletin_Body NTEXT,
      @param_JOL_Bulletin_UpdateTime DATETIME,
      @param_JOL_Bulletin_UpdateUser VARCHAR(50),
      @param_JOL_Bulletin_IsSetTop BIT,
      @param_JOL_Bulletin_ImageUrl VARCHAR(255)
    )
AS 
    UPDATE  dbo.JOL_Bulletin
    SET     JOL_Bulletin_Title = @param_JOL_Bulletin_Title,
            JOL_Bulletin_Source = @param_JOL_Bulletin_Source,
            JOL_Bulletin_Body = @param_JOL_Bulletin_Body,
            JOL_Bulletin_UpdateTime = GETDATE(),
            JOL_Bulletin_UpdateUser = @param_JOL_Bulletin_UpdateUser,
            JOL_Bulletin_IsSetTop = @param_JOL_Bulletin_IsSetTop,
            JOL_Bulletin_ImageUrl = @param_JOL_Bulletin_ImageUrl
    WHERE   JOL_Bulletin_No = @param_JOL_Bulletin_No
GO
